package com.happy_lab_management.demo.student.lab.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.happy_lab_management.entity.Lab;
import com.happy_lab_management.result.Result;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;

@Mapper
@Repository("studentLabMapper")
public interface LabMapper extends BaseMapper<Lab> {
    @Select("SELECT * from lab where technician_id=#{id}")
    List<Lab> selectByTechnicianId(Integer id);

    @Select("SELECT lab_type from lab")
    Result<List<String>> listAlLType();
}
